Important {Points About SQL UNION All
- UNION ALL command helps us to combine results of two or more SELECT statements from different tables.
- The UNION ALL command includes the duplicate records from the SELECT statements whereas the UNION command does not include duplicate records otherwise both the commands are same.
- For performing the UNION ALL operation, it is necessary that both the SELECT statements should have equal number of columns otherwise the resulting expression will result in an error.
SQL UNION ALL
SQL UNION ALL command combines the result of two or more SELECT statements in SQL.
For performing the UNION ALL operation, it is necessary that both the SELECT statements should have an equal number of columns/fields otherwise the resulting expression will result in an error.